DECLARE @x int,@ch varchar(20)
SET @x = 10
SET @ch = 
CASE
   WHEN @x=4 THEN 'a'
   WHEN @x=8 THEN 'b'
   WHEN @x=10 THEN 'c'
END
PRINT @ch